Dynamic support of multiple domains is available in ODBC as follows:
Example
|
SELECT r1.pointidlong, r1.value, r1.timestamp, r2.value, r2.timestamp FROM “[5412]MYSITE.UIS”.realtimevalues AS r1, “[5512]MYSITE.UIS”.realtimevalues AS r2 WHERE r1.pointidlong = r2.pointidlong |
Also:
|
SELECT * FROM oa_tables WHERE table_owner = '[5412]MYSITE.UIS' |
However the following will only work for the ambient domain:
|
SELECT * FROM oa_tables |
|
|
|